﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$LocalizationDBConnection$" formatter="bizobjlist of Translation(language)">
	<Sql>
		SELECT
		Translations.id, Translations.name, Translations.dateCreated, Translations.lastUpdated,
		Translations.autoTranslate,
		Languages.id as languageid,
		Languages.iso6392 as languageiso6392,
		Languages.iso6391 as languageiso6391,
		Languages.regionCode as languageregionCode,
		Languages.englishName as languageenglishName,
		Languages.nativeName as languagenativeName
		FROM
		CompanyTranslations INNER JOIN
		Translations ON CompanyTranslations.translationId = Translations.id INNER JOIN
		Languages ON Translations.languageId = Languages.id
		WHERE
		CompanyTranslations.companyId = @companyId
		ORDER BY
		Translations.name
	</Sql>
	<Param name="companyId" type="UniqueIdentifier" />
</AdoNetDataAccess>